<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>Replication for Existing Databases in the SQL API</title>
    <link rel="stylesheet" href="gettingStarted.css" type="text/css" />
    <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
    <link rel="start" href="index.html" title="Berkeley DB Installation and Build Guide" />
    <link rel="up" href="upgrade_53_toc.html" title="Chapter 12.  Upgrading Berkeley DB 11.2.5.2 applications to Berkeley DB 11.2.5.3" />
    <link rel="prev" href="upgrade_11gr2_53_sql_pragma.html" title="New Berkeley DB SQL API PRAGMAs" />
    <link rel="next" href="upgrade_11gr2_53_xa_mvcc.html" title="Berkeley DB X/Open Compliant XA Resource Manager and Transaction Snapshots" />
  </head>
  <body>
    <div xmlns="" class="navheader">
      <div class="libver">
        <p>Library Version 12.1.6.2</p>
      </div>
      <table width="100%" summary="Navigation header">
        <tr>
          <th colspan="3" align="center">Replication for Existing Databases in the SQL API</th>
        </tr>
        <tr>
          <td width="20%" align="left"><a accesskey="p" href="upgrade_11gr2_53_sql_pragma.html">Prev</a> </td>
          <th width="60%" align="center">Chapter 12.  Upgrading Berkeley DB 11.2.5.2 applications to Berkeley DB 11.2.5.3 </th>
          <td width="20%" align="right"> <a accesskey="n" href="upgrade_11gr2_53_xa_mvcc.html">Next</a></td>
        </tr>
      </table>
      <hr />
    </div>
    <div class="sect1" lang="en" xml:lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="upgrade_11gr2_53_sql_rep"></a>Replication for Existing Databases in the SQL API</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="upgrade_11gr2_53_sql_rep.html#idm140188017014880">PRAGMAs With Permanent Effects</a></span></dt><dt><span class="sect2"><a href="upgrade_11gr2_53_sql_rep.html#idm140188017003936">PRAGMAs That Can Now Operate on Existing Databases</a></span></dt></dl></div><p> 
        Replication can now be enabled on existing SQL databases,
        and replication is now disabled permanently instead of
        temporarily. Replication is enabled on an existing database
        the same way it is enabled on a new database, with one
        restriction. The existing database must configure itself as
        the initial master of a new replication group. To disable
        replication on a database permanently, use <code class="literal">pragma
        replication=OFF;</code>. 
    </p><div class="sect2" lang="en" xml:lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="idm140188017014880"></a>PRAGMAs With Permanent Effects</h3></div></div></div><div class="itemizedlist"><ul type="disc"><li><code class="literal">pragma replication=OFF;</code></li></ul></div></div><div class="sect2" lang="en" xml:lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="idm140188017003936"></a>PRAGMAs That Can Now Operate on Existing Databases</h3></div></div></div><div class="itemizedlist"><ul type="disc"><li><code class="literal">pragma
                    replication_local_site="host:port";</code></li><li><code class="literal">pragma
                    replication_initial_master=ON;</code></li><li><code class="literal">pragma replication=ON;</code></li></ul></div></div>\
</div>
    <div class="navfooter">
      <hr />
      <table width="100%" summary="Navigation footer">
        <tr>
          <td width="40%" align="left"><a accesskey="p" href="upgrade_11gr2_53_sql_pragma.html">Prev</a> </td>
          <td width="20%" align="center">
            <a accesskey="u" href="upgrade_53_toc.html">Up</a>
          </td>
          <td width="40%" align="right"> <a accesskey="n" href="upgrade_11gr2_53_xa_mvcc.html">Next</a></td>
        </tr>
        <tr>
          <td width="40%" align="left" valign="top">New Berkeley DB SQL API PRAGMAs </td>
          <td width="20%" align="center">
            <a accesskey="h" href="index.html">Home</a>
          </td>
          <td width="40%" align="right" valign="top"> Berkeley DB X/Open Compliant XA Resource Manager and Transaction Snapshots </td>
        </tr>
      </table>
    </div>
  </body>
</html>
